<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos -->
			<title>Docs For Class MySQLService</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
			<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
		</head>
		<body>
			<div class="page-body">			
<h2 class="class-name">Class MySQLService</h2>

<a name="sec-description"></a>
<div class="info-box">
	<div class="info-box-title">Description</div>
	<div class="nav-bar">
					<span class="disabled">Description</span> |
													<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
						|											<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
						
					</div>
	<div class="info-box-body">
        		<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I am a REST MySQL Database Manager Service the structure for the url is as follows:</p>
	<ul class="tags">
				<li><span class="field">author:</span> Jonnie Spratley</li>
				<li><span class="field">version:</span> 1.0</li>
				<li><span class="field">name:</span> MySQLService</li>
				<li><span class="field">license:</span> <a href="http://opensource.org/licenses/gpl-license.php">GNU Public License</a></li>
			</ul>
		<p class="notes">
			Located in <a class="field" href="_MySQLService.php.html">/MySQLService.php</a> (line <span class="field"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a56">56</a></span>)
		</p>
		
				
		<pre></pre>
	
			</div>
</div>



	<a name="sec-var-summary"></a>
	<div class="info-box">
		<div class="info-box-title">Variable Summary</span></div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
						<span class="disabled">Vars</span> (<a href="#sec-vars">details</a>)
							| 
									<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
								</div>
		<div class="info-box-body">
			<div class="var-summary">
																																																<div class="var-title">
					<span class="var-type">mixed</span>
					<a href="#$fileSvc" title="details" class="var-name">$fileSvc</a>
				</div>
																<div class="var-title">
					<span class="var-type">mixed</span>
					<a href="#$jquery" title="details" class="var-name">$jquery</a>
				</div>
																<div class="var-title">
					<span class="var-type">private</span>
					<a href="#$mysqli" title="details" class="var-name">$mysqli</a>
				</div>
																<div class="var-title">
					<span class="var-type">mixed</span>
					<a href="#$query_pieces" title="details" class="var-name">$query_pieces</a>
				</div>
											</div>
		</div>
	</div>

	<a name="sec-method-summary"></a>
	<div class="info-box">
		<div class="info-box-title">Method Summary</span></div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
																		<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
				 
				|
						<span class="disabled">Methods</span> (<a href="#sec-methods">details</a>)
		</div>
		<div class="info-box-body">			
			<div class="method-summary">
																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																																												
												<div class="method-definition">
											<span class="method-result"><a href="../MySQLService/MySQLService.html">MySQLService</a></span>
										<a href="#MySQLService" title="details" class="method-name">MySQLService</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$host</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$username</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$password</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#alterTable" title="details" class="method-name">alterTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatQuery</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#analyzeQuery" title="details" class="method-name">analyzeQuery</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$sql</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#analyzeTable" title="details" class="method-name">analyzeTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#checkTable" title="details" class="method-name">checkTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#createBackup" title="details" class="method-name">createBackup</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string</span>&nbsp;<span class="var-name">$whatMode</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#createDatabase" title="details" class="method-name">createDatabase</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#createTable" title="details" class="method-name">createTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#describeTable" title="details" class="method-name">describeTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#dumpIt" title="details" class="method-name">dumpIt</a>
											(<span class="var-type">[var]</span>&nbsp;<span class="var-name">$var</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#executeQuery" title="details" class="method-name">executeQuery</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$sql</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$query</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#exportToJSON" title="details" class="method-name">exportToJSON</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getDatabaseBackups" title="details" class="method-name">getDatabaseBackups</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getDatabases" title="details" class="method-name">getDatabases</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getDatabasesAndTables" title="details" class="method-name">getDatabasesAndTables</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getDatabaseSpace" title="details" class="method-name">getDatabaseSpace</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getHelp" title="details" class="method-name">getHelp</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getOpenTables" title="details" class="method-name">getOpenTables</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getTableColumns" title="details" class="method-name">getTableColumns</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getTableData" title="details" class="method-name">getTableData</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getTableIndex" title="details" class="method-name">getTableIndex</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$database</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$table</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getTableRows" title="details" class="method-name">getTableRows</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getTables" title="details" class="method-name">getTables</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#getUserInfo" title="details" class="method-name">getUserInfo</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$username</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#insertRecord" title="details" class="method-name">insertRecord</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$jsonQuery</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[array]</span>&nbsp;<span class="var-name">$whatQuery</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[boolean]</span>
										<a href="#killProcess" title="details" class="method-name">killProcess</a>
											(<span class="var-type">[int]</span>&nbsp;<span class="var-name">$whatThread</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#makeTimestamp" title="details" class="method-name">makeTimestamp</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#optimizeTable" title="details" class="method-name">optimizeTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">true</span>
										<a href="#ping" title="details" class="method-name">ping</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#pollConnections" title="details" class="method-name">pollConnections</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#pollQueries" title="details" class="method-name">pollQueries</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#pollTraffic" title="details" class="method-name">pollTraffic</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#queryResultToJSON" title="details" class="method-name">queryResultToJSON</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$query</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[xml]</span>
										<a href="#queryResultToXML" title="details" class="method-name">queryResultToXML</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$query</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#removeBackup" title="details" class="method-name">removeBackup</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatFile</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#removeRecord" title="details" class="method-name">removeRecord</a>
											(<span class="var-type">[array]</span>&nbsp;<span class="var-name">$jsonQuery</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#removeTable" title="details" class="method-name">removeTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#renameTable" title="details" class="method-name">renameTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$newName</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#repairTable" title="details" class="method-name">repairTable</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#showSystemPrivileges" title="details" class="method-name">showSystemPrivileges</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#showSystemProcess" title="details" class="method-name">showSystemProcess</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#showSystemStatus" title="details" class="method-name">showSystemStatus</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#showSystemUsers" title="details" class="method-name">showSystemUsers</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#showSystemVariables" title="details" class="method-name">showSystemVariables</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#showTableStatus" title="details" class="method-name">showTableStatus</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$database</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#updateRecord" title="details" class="method-name">updateRecord</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$jsonQuery</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_describeTable" title="details" class="method-name">_describeTable</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$database</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$table</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#_formatUptime" title="details" class="method-name">_formatUptime</a>
											([<span class="var-type">[int]</span>&nbsp;<span class="var-name">$time</span> = <span class="var-default">0</span>])
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getBytes" title="details" class="method-name">_getBytes</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">unknown</span>
										<a href="#_getClients" title="details" class="method-name">_getClients</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getCommands" title="details" class="method-name">_getCommands</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getConnections" title="details" class="method-name">_getConnections</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#_getDatabaseSize" title="details" class="method-name">_getDatabaseSize</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#_getDatabasesTablesAndFields" title="details" class="method-name">_getDatabasesTablesAndFields</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getHandlers" title="details" class="method-name">_getHandlers</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_getHealth" title="details" class="method-name">_getHealth</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getInnoDb" title="details" class="method-name">_getInnoDb</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getKeys" title="details" class="method-name">_getKeys</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getOpen" title="details" class="method-name">_getOpen</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getPerformance" title="details" class="method-name">_getPerformance</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getQcache" title="details" class="method-name">_getQcache</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getQuestions" title="details" class="method-name">_getQuestions</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getReplication" title="details" class="method-name">_getReplication</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getServerInfo" title="details" class="method-name">_getServerInfo</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getShowCommands" title="details" class="method-name">_getShowCommands</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#_getSingleTableStatus" title="details" class="method-name">_getSingleTableStatus</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getSort" title="details" class="method-name">_getSort</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_getStat" title="details" class="method-name">_getStat</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_getTableAndFields" title="details" class="method-name">_getTableAndFields</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#_getTableIndexes" title="details" class="method-name">_getTableIndexes</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[string]</span>
										<a href="#_getTableKey" title="details" class="method-name">_getTableKey</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#_getTables" title="details" class="method-name">_getTables</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_getTableStatus" title="details" class="method-name">_getTableStatus</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getTemp" title="details" class="method-name">_getTemp</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_getThreads" title="details" class="method-name">_getThreads</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">void</span>
										<a href="#_getUnixTimestamp" title="details" class="method-name">_getUnixTimestamp</a>
											(<span class="var-type"></span>&nbsp;<span class="var-name">$unix</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_getUptime" title="details" class="method-name">_getUptime</a>
										()
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_queryStatusToJSON" title="details" class="method-name">_queryStatusToJSON</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$sql</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_queryToARRAY" title="details" class="method-name">_queryToARRAY</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$sql</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[json]</span>
										<a href="#_queryToJSON" title="details" class="method-name">_queryToJSON</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$sql</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_showFieldInfo" title="details" class="method-name">_showFieldInfo</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">[array]</span>
										<a href="#_showTableInfo" title="details" class="method-name">_showTableInfo</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
									</div>
																<div class="method-definition">
											<span class="method-result">error</span>
										<a href="#_throwError" title="details" class="method-name">_throwError</a>
											(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$msg</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$type</span>)
									</div>
								</div>
		</div>
	</div>		

	<a name="sec-vars"></a>
	<div class="info-box">
		<div class="info-box-title">Variables</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
										<a href="#sec-var-summary">Vars</a> (<span class="disabled">details</span>)
						
			
										| 
									<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
							
					</div>
		<div class="info-box-body">
			<a name="var$fileSvc" id="$fileSvc"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<span class="var-title">
			<span class="var-type">mixed</span>
			<span class="var-name">$fileSvc</span>
						(line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a65">65</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	
		
		

</div>
<a name="var$jquery" id="$jquery"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<span class="var-title">
			<span class="var-type">mixed</span>
			<span class="var-name">$jquery</span>
						(line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a66">66</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	
		
		

</div>
<a name="var$mysqli" id="$mysqli"><!-- --></A>
<div class="evenrow">

	<div class="var-header">
		<span class="var-title">
			<span class="var-type">private</span>
			<span class="var-name">$mysqli</span>
						(line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a63">63</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I am the database link</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	
		
		

</div>
<a name="var$query_pieces" id="$query_pieces"><!-- --></A>
<div class="oddrow">

	<div class="var-header">
		<span class="var-title">
			<span class="var-type">mixed</span>
			<span class="var-name">$query_pieces</span>
			 = <span class="var-default">array ()</span>			(line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a64">64</a></span>)
		</span>
	</div>

	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	
		
		

</div>
						
		</div>
	</div>
	
	<a name="sec-methods"></a>
	<div class="info-box">
		<div class="info-box-title">Methods</div>
		<div class="nav-bar">
			<a href="#sec-description">Description</a> |
															<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
																	<a href="#sec-method-summary">Methods</a> (<span class="disabled">details</span>)
						
		</div>
		<div class="info-box-body">
			<A NAME='method_detail'></A>

<a name="methodMySQLService" id="MySQLService"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">Constructor MySQLService</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a77">77</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I hold alot of access to monitor and manager mysql tables</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result"><a href="../MySQLService/MySQLService.html">MySQLService</a></span>
		<span class="method-name">
			MySQLService
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$host</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$username</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$password</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$host</span><span class="var-description">: Host name</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$username</span><span class="var-description">: User name</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$password</span><span class="var-description">: User password</span>			</li>
				</ul>
		
			
	</div>
<a name="methodalterTable" id="alterTable"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">alterTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a699">699</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I alter a database table</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			alterTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatQuery</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the name of the new table</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatQuery</span><span class="var-description">: a query array of what to change</span>			</li>
				</ul>
		
			
	</div>
<a name="methodanalyzeQuery" id="analyzeQuery"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">analyzeQuery</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a875">875</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I analyze a query are return the statistics</p>
	<ul class="tags">
				<li><span class="field">return:</span> json results</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			analyzeQuery
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$sql</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$sql</span><span class="var-description">: query string</span>			</li>
				</ul>
		
			
	</div>
<a name="methodanalyzeTable" id="analyzeTable"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">analyzeTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a820">820</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I analyze a table</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			analyzeTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodcheckTable" id="checkTable"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">checkTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a834">834</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I check a table</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			checkTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodcreateBackup" id="createBackup"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">createBackup</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1001">1001</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I export data from the database</p>
	<ul class="tags">
				<li><span class="field">return:</span> the filename of the file.</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			createBackup
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string</span>&nbsp;<span class="var-name">$whatMode</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span>			</li>
					<li>
				<span class="var-type">[string</span>
				<span class="var-name">$whatMode</span><span class="var-description">: all, db_structure, db_data, tbl_structure, tbl_data ] $whatMode</span>			</li>
				</ul>
		
			
	</div>
<a name="methodcreateDatabase" id="createDatabase"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">createDatabase</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a652">652</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I create a database</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result outcome</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			createDatabase
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the name of the database</span>			</li>
				</ul>
		
			
	</div>
<a name="methodcreateTable" id="createTable"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">createTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a674">674</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I create a table</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			createTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the name of the new table</span>			</li>
				</ul>
		
			
	</div>
<a name="methoddescribeTable" id="describeTable"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">describeTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a291">291</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I describe a table</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			describeTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methoddumpIt" id="dumpIt"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">dumpIt</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1651">1651</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I format debug dumps</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			dumpIt
		</span>
					(<span class="var-type">[var]</span>&nbsp;<span class="var-name">$var</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[var]</span>
				<span class="var-name">$var</span><span class="var-description">: the variable you with to dump</span>			</li>
				</ul>
		
			
	</div>
<a name="methodexecuteQuery" id="executeQuery"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">executeQuery</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1516">1516</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I execute a query</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			executeQuery
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$sql</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$query</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$query</span><span class="var-description">: the query to execute</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$sql</span>			</li>
				</ul>
		
			
	</div>
<a name="methodexportToJSON" id="exportToJSON"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">exportToJSON</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a986">986</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I execute a query and return json</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			exportToJSON
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetDatabaseBackups" id="getDatabaseBackups"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">getDatabaseBackups</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1065">1065</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get a list of all the backups in the backup folder</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getDatabaseBackups
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodgetDatabases" id="getDatabases"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">getDatabases</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a214">214</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all the databases</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getDatabases
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodgetDatabasesAndTables" id="getDatabasesAndTables"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">getDatabasesAndTables</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a180">180</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all databases, tables, columns, and fields in the database.</p>
<p class="description"><p>Formatted specially for Flex's Tree control.</p></p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getDatabasesAndTables
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodgetDatabaseSpace" id="getDatabaseSpace"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">getDatabaseSpace</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a594">594</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the size of all databases in the database</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getDatabaseSpace
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodgetHelp" id="getHelp"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">getHelp</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1627">1627</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get help from the mysql database</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getHelp
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodgetOpenTables" id="getOpenTables"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">getOpenTables</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a333">333</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all open tables for a database</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getOpenTables
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database name</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetTableColumns" id="getTableColumns"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">getTableColumns</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a135">135</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I show all of the columns for a specified table.</p>
	<ul class="tags">
				<li><span class="field">return:</span> Json of all the columns</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getTableColumns
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetTableData" id="getTableData"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">getTableData</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1503">1503</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all the table data</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getTableData
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetTableIndex" id="getTableIndex"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">getTableIndex</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a167">167</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the primary key for the table.</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getTableIndex
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$database</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$table</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$database</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$table</span><span class="var-description">: the table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatDatabase</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatTable</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetTableRows" id="getTableRows"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">getTableRows</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a347">347</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get a count of rows from the table</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getTableRows
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetTables" id="getTables"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">getTables</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a253">253</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all tables in the database</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getTables
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the name of the database</span>			</li>
				</ul>
		
			
	</div>
<a name="methodgetUserInfo" id="getUserInfo"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">getUserInfo</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a311">311</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get user information</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			getUserInfo
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$username</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$username</span><span class="var-description">: the users name</span>			</li>
				</ul>
		
			
	</div>
<a name="methodinsertRecord" id="insertRecord"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">insertRecord</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a772">772</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I insert data into the database</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			insertRecord
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$jsonQuery</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[array]</span>&nbsp;<span class="var-name">$whatQuery</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
					<li>
				<span class="var-type">[array]</span>
				<span class="var-name">$whatQuery</span><span class="var-description">: Array of Key/Value pairs for inserting in the database</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$jsonQuery</span>			</li>
				</ul>
		
			
	</div>
<a name="methodkillProcess" id="killProcess"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">killProcess</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1093">1093</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I kill a thread that is connected or running</p>
	<ul class="tags">
				<li><span class="field">return:</span> true or false</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[boolean]</span>
		<span class="method-name">
			killProcess
		</span>
					(<span class="var-type">[int]</span>&nbsp;<span class="var-name">$whatThread</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[int]</span>
				<span class="var-name">$whatThread</span><span class="var-description">: the id of the thread</span>			</li>
				</ul>
		
			
	</div>
<a name="methodmakeTimestamp" id="makeTimestamp"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">makeTimestamp</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1666">1666</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I make a formatted timestamp.</p>
<p class="description"><p><div class="src-code"><ol><li><div class="src-line">&nbsp;<span class="src-num">2008</span>-<span class="src-num">12</span>-<span class="src-num">30&nbsp;22</span>:<span class="src-num">40</span>:<span class="src-num">00</span></div></li>
</ol></div></p></p>
	<ul class="tags">
				<li><span class="field">return:</span> a timestamp</li>
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			makeTimestamp
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodoptimizeTable" id="optimizeTable"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">optimizeTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a848">848</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I optimize a table</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			optimizeTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodping" id="ping"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">ping</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1607">1607</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I ping mysql for a connection</p>
	<ul class="tags">
				<li><span class="field">return:</span> or false</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">true</span>
		<span class="method-name">
			ping
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodpollConnections" id="pollConnections"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">pollConnections</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1471">1471</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I am a polling method for checking the current connections.</p>
	<ul class="tags">
				<li><span class="field">return:</span> encoded results</li>
				<li><span class="field">access:</span> public</li>
				<li><span class="field">example:</span> example not found</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			pollConnections
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodpollQueries" id="pollQueries"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">pollQueries</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1420">1420</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I am a polling method for checking the current select statements.</p>
	<ul class="tags">
				<li><span class="field">return:</span> encoded results</li>
				<li><span class="field">access:</span> public</li>
				<li><span class="field">example:</span> example not found</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			pollQueries
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodpollTraffic" id="pollTraffic"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">pollTraffic</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1445">1445</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I am a polling method for checking the current bytes sent.</p>
	<ul class="tags">
				<li><span class="field">return:</span> encoded results</li>
				<li><span class="field">access:</span> public</li>
				<li><span class="field">example:</span> example not found</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			pollTraffic
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodqueryResultToJSON" id="queryResultToJSON"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">queryResultToJSON</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a974">974</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I execute a query and return JSON</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			queryResultToJSON
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$query</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$query</span><span class="var-description">: the query</span>			</li>
				</ul>
		
			
	</div>
<a name="methodqueryResultToXML" id="queryResultToXML"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">queryResultToXML</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a941">941</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I execute a query and return XML</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[xml]</span>
		<span class="method-name">
			queryResultToXML
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$query</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$query</span><span class="var-description">: the query</span>			</li>
				</ul>
		
			
	</div>
<a name="methodremoveBackup" id="removeBackup"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">removeBackup</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1070">1070</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			removeBackup
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatFile</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatDatabase</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatFile</span>			</li>
				</ul>
		
			
	</div>
<a name="methodremoveRecord" id="removeRecord"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">removeRecord</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a797">797</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I remove data from the database</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			removeRecord
		</span>
					(<span class="var-type">[array]</span>&nbsp;<span class="var-name">$jsonQuery</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[array]</span>
				<span class="var-name">$jsonQuery</span><span class="var-description">: the value to which remove by</span>			</li>
				</ul>
		
			
	</div>
<a name="methodremoveTable" id="removeTable"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">removeTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a722">722</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I remove a table</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			removeTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodrenameTable" id="renameTable"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">renameTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a746">746</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I rename a table</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			renameTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$newName</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$newName</span><span class="var-description">: the new name</span>			</li>
				</ul>
		
			
	</div>
<a name="methodrepairTable" id="repairTable"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">repairTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a862">862</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I repair a table</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			repairTable
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="methodshowSystemPrivileges" id="showSystemPrivileges"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">showSystemPrivileges</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1124">1124</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I show all system privileges</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			showSystemPrivileges
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodshowSystemProcess" id="showSystemProcess"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">showSystemProcess</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1144">1144</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I show system processes</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			showSystemProcess
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodshowSystemStatus" id="showSystemStatus"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">showSystemStatus</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1134">1134</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I show the system status</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			showSystemStatus
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodshowSystemUsers" id="showSystemUsers"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">showSystemUsers</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1154">1154</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I show all of the systems users</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			showSystemUsers
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodshowSystemVariables" id="showSystemVariables"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">showSystemVariables</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1114">1114</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I show all mysql system variables</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			showSystemVariables
		</span>
				()
			</div>
	
		
			
	</div>
<a name="methodshowTableStatus" id="showTableStatus"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">showTableStatus</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a148">148</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all tables in database</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			showTableStatus
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$database</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$database</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatDatabase</span>			</li>
				</ul>
		
			
	</div>
<a name="methodupdateRecord" id="updateRecord"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">updateRecord</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a786">786</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I update data from the database  UPDATE db.tbl SET name='value'</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			updateRecord
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$jsonQuery</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$jsonQuery</span><span class="var-description">: Array of Key/Value pairs for updating the database</span>			</li>
				</ul>
		
			
	</div>
<a name="method_describeTable" id="_describeTable"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_describeTable</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a419">419</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I describe a table for the getDatabasesAndTables() method</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_describeTable
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatTable</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$database</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$table</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$database</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$table</span><span class="var-description">: the table</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatDatabase</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatTable</span>			</li>
				</ul>
		
			
	</div>
<a name="method_formatUptime" id="_formatUptime"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_formatUptime</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1679">1679</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I format uptime from MySQL</p>
	<ul class="tags">
				<li><span class="field">return:</span> the new time</li>
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			_formatUptime
		</span>
					([<span class="var-type">[int]</span>&nbsp;<span class="var-name">$time</span> = <span class="var-default">0</span>])
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[int]</span>
				<span class="var-name">$time</span><span class="var-description">: the old time</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getBytes" id="_getBytes"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getBytes</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1318">1318</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get mysql bytes</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getBytes
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getClients" id="_getClients"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getClients</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1308">1308</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the aborted clients and connections</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">unknown</span>
		<span class="method-name">
			_getClients
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getCommands" id="_getCommands"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getCommands</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1338">1338</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the commands</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getCommands
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getConnections" id="_getConnections"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getConnections</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1298">1298</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the connections</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getConnections
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getDatabaseSize" id="_getDatabaseSize"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getDatabaseSize</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a612">612</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the database size for all tables</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			_getDatabaseSize
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database name</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getDatabasesTablesAndFields" id="_getDatabasesTablesAndFields"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getDatabasesTablesAndFields</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a492">492</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			_getDatabasesTablesAndFields
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getHandlers" id="_getHandlers"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getHandlers</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1209">1209</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the handlers variables</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getHandlers
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getHealth" id="_getHealth"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getHealth</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1382">1382</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the health of a mysql server</p>
	<ul class="tags">
				<li><span class="field">return:</span> of results</li>
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_getHealth
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getInnoDb" id="_getInnoDb"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getInnoDb</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1258">1258</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get InnoDB</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getInnoDb
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getKeys" id="_getKeys"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getKeys</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1268">1268</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the key cache</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getKeys
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getOpen" id="_getOpen"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getOpen</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1199">1199</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get open tables</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getOpen
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getPerformance" id="_getPerformance"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getPerformance</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1278">1278</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the performance of mysql.</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getPerformance
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getQcache" id="_getQcache"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getQcache</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1248">1248</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the query cache</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getQcache
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getQuestions" id="_getQuestions"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getQuestions</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1238">1238</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the recent queries</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getQuestions
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getReplication" id="_getReplication"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getReplication</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1328">1328</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all the slave hosts</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getReplication
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getServerInfo" id="_getServerInfo"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getServerInfo</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1164">1164</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get server info</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getServerInfo
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getShowCommands" id="_getShowCommands"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getShowCommands</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1348">1348</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I show all of the SHOW commands</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getShowCommands
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getSingleTableStatus" id="_getSingleTableStatus"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getSingleTableStatus</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a451">451</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			_getSingleTableStatus
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatDatabase</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatTable</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getSort" id="_getSort"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getSort</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1288">1288</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all the sort</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getSort
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getStat" id="_getStat"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getStat</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1358">1358</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the stats of the mysql connection</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_getStat
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getTableAndFields" id="_getTableAndFields"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getTableAndFields</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a464">464</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get tables and fields</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_getTableAndFields
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getTableIndexes" id="_getTableIndexes"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getTableIndexes</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a431">431</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			_getTableIndexes
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type"></span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatDatabase</span>			</li>
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatTable</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getTableKey" id="_getTableKey"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getTableKey</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a572">572</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the key for the table.</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[string]</span>
		<span class="method-name">
			_getTableKey
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getTables" id="_getTables"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getTables</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a375">375</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			_getTables
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$whatDatabase</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$whatDatabase</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getTableStatus" id="_getTableStatus"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getTableStatus</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a444">444</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the table status for a table only when called from getDatabases()</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_getTableStatus
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getTemp" id="_getTemp"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getTemp</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1189">1189</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the temp size</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getTemp
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getThreads" id="_getThreads"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getThreads</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1179">1179</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get all of the threads</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_getThreads
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_getUnixTimestamp" id="_getUnixTimestamp"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_getUnixTimestamp</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1228">1228</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">void</span>
		<span class="method-name">
			_getUnixTimestamp
		</span>
					(<span class="var-type"></span>&nbsp;<span class="var-name">$unix</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type"></span>
				<span class="var-name">$unix</span>			</li>
				</ul>
		
			
	</div>
<a name="method_getUptime" id="_getUptime"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_getUptime</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1219">1219</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the server uptime</p>
	<ul class="tags">
				<li><span class="field">access:</span> public</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_getUptime
		</span>
				()
			</div>
	
		
			
	</div>
<a name="method_queryStatusToJSON" id="_queryStatusToJSON"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_queryStatusToJSON</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1572">1572</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the query status</p>
	<ul class="tags">
				<li><span class="field">return:</span> mysql status with the ('_') striped out</li>
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_queryStatusToJSON
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$sql</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$sql</span>			</li>
				</ul>
		
			
	</div>
<a name="method_queryToARRAY" id="_queryToARRAY"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_queryToARRAY</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1553">1553</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I execute a query and return the result as an array.</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result array</li>
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_queryToARRAY
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$sql</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$sql</span><span class="var-description">: the query to be executed</span>			</li>
				</ul>
		
			
	</div>
<a name="method_queryToJSON" id="_queryToJSON"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_queryToJSON</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1536">1536</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I execute a query and return the results as json.</p>
	<ul class="tags">
				<li><span class="field">return:</span> the result in json</li>
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[json]</span>
		<span class="method-name">
			_queryToJSON
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$sql</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$sql</span><span class="var-description">: the query to be executed</span>			</li>
				</ul>
		
			
	</div>
<a name="method_showFieldInfo" id="_showFieldInfo"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_showFieldInfo</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a551">551</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get the fields for a table</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_showFieldInfo
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatTable</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatTable</span><span class="var-description">: the table</span>			</li>
				</ul>
		
			
	</div>
<a name="method_showTableInfo" id="_showTableInfo"><!-- --></a>
<div class="oddrow">
	
	<div class="method-header">
		<span class="method-title">_showTableInfo</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a531">531</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I get information about the table.</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">[array]</span>
		<span class="method-name">
			_showTableInfo
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$whatDatabase</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$whatDatabase</span><span class="var-description">: the database</span>			</li>
				</ul>
		
			
	</div>
<a name="method_throwError" id="_throwError"><!-- --></a>
<div class="evenrow">
	
	<div class="method-header">
		<span class="method-title">_throwError</span> (line <span class="line-number"><a href="../__filesource/fsource_MySQLService__MySQLService.php.html#a1721">1721</a></span>)
	</div> 
	
	<!-- ========== Info from phpDoc block ========= -->
<p class="short-description">I try and throw an error.</p>
	<ul class="tags">
				<li><span class="field">access:</span> private</li>
			</ul>
	
	<div class="method-signature">
		<span class="method-result">error</span>
		<span class="method-name">
			_throwError
		</span>
					(<span class="var-type">[string]</span>&nbsp;<span class="var-name">$msg</span>, <span class="var-type">[string]</span>&nbsp;<span class="var-name">$type</span>)
			</div>
	
			<ul class="parameters">
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$msg</span><span class="var-description">: the message of the mess</span>			</li>
					<li>
				<span class="var-type">[string]</span>
				<span class="var-name">$type</span><span class="var-description">: the type of error</span>			</li>
				</ul>
		
			
	</div>
						
		</div>
	</div>


	<p class="notes" id="credit">
		Documentation generated on Mon, 23 Feb 2009 19:14:05 -0800 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.1</a>
	</p>
	</div></body>
</html>